/*
 Navicat MySQL Data Transfer

 Source Server         : 127.0.0.1
 Source Server Version : 50538
 Source Host           : localhost
 Source Database       : vancl

 Target Server Version : 50538
 File Encoding         : utf-8

 Date: 09/12/2015 16:16:37 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `vcshop_admin`
-- ----------------------------
DROP TABLE IF EXISTS `vcshop_admin`;
CREATE TABLE `vcshop_admin` (
  `aid` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `username` char(20) NOT NULL DEFAULT '' COMMENT '用户名称',
  `password` char(32) NOT NULL DEFAULT '' COMMENT '密码',
  `logintime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上次登录时间',
  `loginip` char(20) NOT NULL DEFAULT '‘’' COMMENT '上次登录的ip地址',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='后台用户表';

-- ----------------------------
--  Records of `vcshop_admin`
-- ----------------------------
BEGIN;
INSERT INTO `vcshop_admin` VALUES ('1', 'admin', '21232f297a57a5a743894a0e4a801fc3', '0', '‘’');
COMMIT;

-- ----------------------------
--  Table structure for `vcshop_user`
-- ----------------------------
DROP TABLE IF EXISTS `vcshop_user`;
CREATE TABLE `vcshop_user` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` char(20) NOT NULL DEFAULT '' COMMENT '用户名称',
  `password` char(32) NOT NULL DEFAULT '' COMMENT '密码',
  `nickname` varchar(25) NOT NULL DEFAULT '' COMMENT '昵称',
  `is_lock` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否被锁定',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `username_UNIQUE` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
--  Records of `vcshop_user`
-- ----------------------------
BEGIN;
INSERT INTO `vcshop_user` VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '', '0'), ('2', 'admin888', 'e10adc3949ba59abbe56e057f20f883e', '', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
